* This file: ./replication\table_f15\table_e15_correlation_matrix.do

clear
input str3 iso3c	c1	c2	c3	c4	c5	c6	c7
BEL	0.35	0.185	2.88	14	3731	.	0.717
CYP	0.352	0.183	3.42	5	1147	-0.002	0.761
DEU	0.228	0.119	1.76	14.8	3882	1.118	0.48
ESP	0.366	0.195	2.56	11.3	2392	-0.231	0.831
EST	0.544	0.261	6.06	5.7	851	0.181	0.768
FRA	0.295	0.142	1.92	14	3401	3.921	0.585
GRC	0.354	0.187	2.91	9	1737	.	0.725
HUN	0.366	0.183	2.74	7.1	1097	0.148	0.844
IRL	0.472	0.24	3.59	9.6	2678	0.302	0.714
ITA	0.433	0.23	4.17	10.4	2526	.	0.686
LUX	0.34	0.172	2.19	10	5189	0.474	0.688
LVA	0.463	0.212	3.55	5	672	0.353	0.762
MLT	0.425	0.205	4.52	8.2	1462	0.393	0.794
NLD	0.204	0.109	1.68	13.1	4016	2.617	0.623
PRT	0.668	0.329	5.54	10.5	1825	0.184	0.763
SVK	0.329	0.152	2.7	8.4	1245	.	0.878
SVN	0.493	0.223	2.85	9.6	1935	.	0.778
end


label var c1	"CoV of interest rates, source (a)"
label var c2	"Gini of interest rates, source (a)"	
label var c3	"P90/P10 interest rates, source (a)"
label var c4	"Income protection (% of GDP), source (b)"
label var c5	"Income protection (PPS per capita), source (a)"
label var c6	"Home ownership subsidies, source (c)"
label var c7	"Home ownership rate, source (a)"

pwcorr c?, star(0.1)
matrix list r(C), format(%4.3f)


/*
Note & sources:
Variables are averaged across available years since 1994. Variable (6) refers to around 2015, and variable (7) to around 2010-2014.
a) Interest rate and homeownership data are from the Household Finance and Consumption Survey (HFCS), waves 1 and 2. [.\Rehm\Data\HFCS\jan2017]
b) Income protection = Social protection expenditures for sickness/healthcare + disability + survivor + unemployment. Source: http://ec.europa.eu/eurostat/cache/metadata/en/spr_esms.htm / http://appsso.eurostat.ec.europa.eu/nui/show.do?dataset=spr_exp_sum. [.\Rehm\iversen\credit_markets\data\eurostat_spending\eurostat_spending.do]
c) Average of three measures of public support for home ownership: (i) Public spending on grants and financial support to home buyers [PH2.1]; (ii) Forgone tax revenue due to tax relief for access to home ownership [PH2.2]; (iii) Spending on housing allowances by type of housing related costs covered [PH3.1]. Source: http://www.oecd.org/social/affordable-housing-database.htm. Some imputation (see "Imputing subsidy data.do").

*/	
